Box 1: Yes -The following list provides advantages to using aggregations:Query performance over big data - as users interact with visuals on Power BI reportsDAX queries are submitted to the datasetBoost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level.Unlock big data in a way that would otherwise be impossible.Box 2: Yes -With Power BI Desktop, you can connect to many different types of data sources, then shape the data to meet your needs, enabling you to create visual reports to share with others. Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the rst row as headers, and so on. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.Reference:https://docs.microsoft.com/en-us/power-bi/desktop-aggregationshttps://docs.microsoft.com/en-us/power-platform/admin/use-power-bihttps://powerapps.microsoft.com/sv-se/blog/powerbi-powerapps-visual/
Box 1: Yes -
The following list provides advantages to using aggregations:
Query performance over big data - as users interact with visuals on Power BI reports
DAX queries are submitted to the dataset
Boost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level.
Unlock big data in a way that would otherwise be impossible.
Box 2: Yes -
With Power BI Desktop, you can connect to many different types of data sources, then shape the data to meet your needs, enabling you to create visual reports to share with others. Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the rst row as headers, and so on. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations
https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi
https://powerapps.microsoft.com/sv-se/blog/powerbi-powerapps-visual/